/*
 Navicat MySQL Data Transfer

 Source Server         : 129
 Source Server Type    : MySQL
 Source Server Version : 50553
 Source Host           : 121.40.178.129
 Source Database       : lslease

 Target Server Type    : MySQL
 Target Server Version : 50553
 File Encoding         : utf-8

 Date: 10/31/2017 13:39:28 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `app_furniture`
-- ----------------------------
DROP TABLE IF EXISTS `app_furniture`;
CREATE TABLE `app_furniture` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设施ID',
  `washing_machine_flag` int(11) NOT NULL DEFAULT '1' COMMENT '是否有洗衣机 1 有 2 没有',
  `micro_wave_oven_flag` int(11) NOT NULL DEFAULT '2' COMMENT '是否有微波炉 1 有 2 无',
  `calorifier_flag` int(11) NOT NULL COMMENT '是否有热水器 1 有 2 没有',
  `refrigerator_flag` int(11) NOT NULL DEFAULT '1' COMMENT '是否有冰箱 1 有 2 无',
  `range_hood_flag` int(11) NOT NULL DEFAULT '1' COMMENT '是否有油烟机 1 有 2 无',
  `sofa_flag` int(11) NOT NULL DEFAULT '2' COMMENT '是否有沙发 1 有 2 无',
  `bed_flag` int(11) NOT NULL DEFAULT '1' COMMENT '是否有床 1 有 2 无',
  `desk_flag` int(11) NOT NULL DEFAULT '2' COMMENT '是否有桌子 1 有 2 无',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10047 DEFAULT CHARSET=utf8 COMMENT='房源配套家具表';

-- ----------------------------
--  Records of `app_furniture`
-- ----------------------------
BEGIN;
INSERT INTO `app_furniture` VALUES ('10000', '1', '2', '0', '2', '2', '2', '2', '2', null, null, '-1', null, null, null, null), ('10001', '1', '2', '0', '2', '2', '2', '2', '2', null, null, '-1', null, null, null, null), ('10002', '1', '1', '0', '1', '1', '1', '1', '1', '2017-10-19 19:06:24', '2017-10-19 19:06:24', '1', null, null, null, null), ('10003', '1', '1', '0', '1', '1', '1', '1', '1', '2017-10-22 17:06:55', '2017-10-22 17:06:55', '-1', null, null, null, null), ('10004', '1', '1', '0', '1', '1', '1', '1', '1', '2017-10-22 17:07:33', '2017-10-22 17:07:33', '1', null, null, null, null), ('10005', '2', '2', '2', '2', '1', '2', '1', '2', '2017-10-26 10:44:21', '2017-10-26 10:44:21', '1', null, null, null, null), ('10006', '1', '1', '2', '1', '1', '1', '1', '1', '2017-10-26 10:48:46', '2017-10-26 10:48:46', '1', null, null, null, null), ('10007', '2', '2', '2', '1', '1', '1', '1', '2', '2017-10-26 15:01:43', '2017-10-26 15:01:43', '1', null, null, null, null), ('10008', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:13:04', '2017-10-26 15:13:04', '1', null, null, null, null), ('10009', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:24:57', '2017-10-26 15:24:57', '1', null, null, null, null), ('10010', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:47:19', '2017-10-26 15:47:19', '1', null, null, null, null), ('10011', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:51:11', '2017-10-26 15:51:11', '1', null, null, null, null), ('10012', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:52:24', '2017-10-26 15:52:24', '1', null, null, null, null), ('10013', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 15:57:48', '2017-10-26 15:57:48', '1', null, null, null, null), ('10014', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:17:24', '2017-10-26 16:17:24', '1', null, null, null, null), ('10015', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:19:04', '2017-10-26 16:19:04', '1', null, null, null, null), ('10016', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:35:54', '2017-10-26 16:35:54', '1', null, null, null, null), ('10017', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:36:28', '2017-10-26 16:36:28', '1', null, null, null, null), ('10018', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:38:09', '2017-10-26 16:38:09', '1', null, null, null, null), ('10019', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:41:45', '2017-10-26 16:41:45', '1', null, null, null, null), ('10020', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:43:34', '2017-10-26 16:43:34', '1', null, null, null, null), ('10021', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:44:30', '2017-10-26 16:44:30', '1', null, null, null, null), ('10022', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:44:58', '2017-10-26 16:44:58', '1', null, null, null, null), ('10023', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:46:34', '2017-10-26 16:46:34', '1', null, null, null, null), ('10024', '1', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:52:52', '2017-10-26 16:52:52', '1', null, null, null, null), ('10025', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:54:01', '2017-10-26 16:54:01', '1', null, null, null, null), ('10026', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 16:57:52', '2017-10-26 16:57:52', '1', null, null, null, null), ('10027', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:00:01', '2017-10-26 17:00:01', '1', null, null, null, null), ('10028', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:01:59', '2017-10-26 17:01:59', '1', null, null, null, null), ('10029', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:02:35', '2017-10-26 17:02:35', '1', null, null, null, null), ('10030', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:03:26', '2017-10-26 17:03:26', '1', null, null, null, null), ('10031', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:18:03', '2017-10-26 17:18:03', '1', null, null, null, null), ('10032', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:49:19', '2017-10-26 17:49:19', '1', null, null, null, null), ('10033', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-26 17:50:48', '2017-10-26 17:50:48', '1', null, null, null, null), ('10034', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 08:53:52', '2017-10-27 08:53:52', '1', null, null, null, null), ('10035', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 08:54:47', '2017-10-27 08:54:47', '1', null, null, null, null), ('10036', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 09:12:21', '2017-10-27 09:12:21', '1', null, null, null, null), ('10037', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 09:13:29', '2017-10-27 09:13:29', '1', null, null, null, null), ('10038', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 09:14:54', '2017-10-27 09:14:54', '1', null, null, null, null), ('10039', '2', '1', '2', '2', '2', '2', '1', '2', '2017-10-27 09:18:27', '2017-10-27 09:18:27', '1', null, null, null, null), ('10040', '1', '1', '2', '1', '2', '1', '1', '1', '2017-10-27 10:51:06', '2017-10-27 10:51:06', '1', null, null, null, null), ('10041', '1', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 10:58:09', '2017-10-27 10:58:09', '1', null, null, null, null), ('10042', '1', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 11:01:55', '2017-10-27 11:01:55', '1', null, null, null, null), ('10043', '2', '1', '2', '2', '2', '2', '1', '2', '2017-10-27 11:03:28', '2017-10-27 11:03:28', '1', null, null, null, null), ('10044', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 11:06:06', '2017-10-27 11:06:06', '1', null, null, null, null), ('10045', '2', '2', '2', '2', '2', '2', '1', '2', '2017-10-27 11:11:00', '2017-10-27 11:11:00', '1', null, null, null, null), ('10046', '1', '1', '2', '1', '1', '1', '1', '1', '2017-10-27 11:18:10', '2017-10-27 11:18:10', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_house`
-- ----------------------------
DROP TABLE IF EXISTS `app_house`;
CREATE TABLE `app_house` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房源ID',
  `house_name` varchar(200) NOT NULL COMMENT '房源名称',
  `company_id` int(11) NOT NULL COMMENT '公司ID',
  `landlord_id` int(11) NOT NULL COMMENT '房东ID',
  `house_address` varchar(200) NOT NULL COMMENT '房源地址',
  `house_pic_id` int(11) DEFAULT NULL COMMENT '房源图片',
  `house_furniture_id` int(11) DEFAULT NULL COMMENT '房源配套家具',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10065 DEFAULT CHARSET=utf8 COMMENT='房源表';

-- ----------------------------
--  Records of `app_house`
-- ----------------------------
BEGIN;
INSERT INTO `app_house` VALUES ('10000', 'æåå¤§éæ­¥è¡è¡1å¹¢301', '1', '10004', 'æ»¨æ±åºæ¿åºæåå¤§éåä¸è¡åä¸ä¸­å¿', null, null, '2017-10-19 16:30:02', '2017-10-19 16:30:02', '1', null, null, null, null), ('10001', 'æåå¤§éæ­¥è¡è¡1å¹¢301', '1', '10004', 'æ»¨æ±åºæ¿åºæåå¤§éåä¸è¡åä¸ä¸­å¿', null, null, '2017-10-19 16:35:01', '2017-10-19 16:35:01', '1', null, null, null, null), ('10002', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 16:50:33', '2017-10-19 16:50:33', '-1', null, null, null, null), ('10003', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:02:20', '2017-10-19 17:02:20', '1', null, null, null, null), ('10004', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:09:14', '2017-10-19 17:09:14', '1', null, null, null, null), ('10005', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:13:49', '2017-10-19 17:13:49', '1', null, null, null, null), ('10006', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:14:59', '2017-10-19 17:14:59', '1', null, null, null, null), ('10007', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:16:08', '2017-10-19 17:16:08', '1', null, null, null, null), ('10008', 'xingguangdadao301', '1', '10005', 'bingjiangquzhengfu', null, null, '2017-10-19 17:18:36', '2017-10-19 17:18:36', '-1', null, null, null, null), ('10009', '111111111111111', '1', '10005', '2222222222222', '10011', '10002', '2017-10-19 17:21:03', '2017-10-19 22:34:44', '1', null, null, null, null), ('10010', '陈苗发的测试房源', '1', '10006', '江晖南路8号909房间', null, null, '2017-10-19 17:18:36', '2017-10-22 17:21:14', '1', '', '', '', ''), ('10011', '111111111111111', '1', '10010', '2222222222222', null, '10004', '2017-10-22 17:00:33', '2017-10-22 17:16:26', '-1', null, null, null, null), ('10012', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', '10022', null, '2017-10-22 17:32:42', '2017-10-27 09:08:51', '1', null, null, null, null), ('10013', 'aaaaaaaaaaaaaaa0000', '1', '10010', 'bbbbbbbbbbbbbbbbb00000', null, null, '2017-10-22 17:32:58', '2017-10-22 17:32:58', '1', null, null, null, null), ('10014', '媛媛的小屋', '1', '10017', '湘湖家园', null, null, '2017-10-24 17:26:00', '2017-10-24 17:26:00', '1', null, null, null, null), ('10015', 'ds', '1', '10017', '123', null, null, '2017-10-25 09:02:11', '2017-10-25 09:02:11', '1', null, null, null, null), ('10016', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', '10018', null, '2017-10-25 14:53:53', '2017-10-26 16:41:14', '1', null, null, null, null), ('10017', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', '10020', null, '2017-10-25 15:02:10', '2017-10-26 17:54:42', '1', null, null, null, null), ('10018', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', null, null, '2017-10-25 15:02:11', '2017-10-25 15:02:11', '1', null, null, null, null), ('10019', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', null, null, '2017-10-25 15:03:28', '2017-10-25 15:03:28', '1', null, null, null, null), ('10020', 'aaaaaaaaaaaaaaa', '1', '10010', 'bbbbbbbbbbbbbbbbb', null, null, '2017-10-25 15:03:54', '2017-10-25 15:03:54', '1', null, null, null, null), ('10024', 'yy', '1', '10016', '周雨家', null, null, '2017-10-26 14:33:25', '2017-10-26 14:33:25', '1', null, null, null, null), ('10025', '1', '1', '10032', '12', '10014', '10007', '2017-10-26 15:01:36', '2017-10-26 15:03:45', '1', null, null, null, null), ('10026', '12', '1', '10032', '123', '10015', '10008', '2017-10-26 15:13:02', '2017-10-26 15:13:10', '1', null, null, null, null), ('10058', '盘丝洞', '1', '10031', '花果山水帘大道101号', '10025', '10040', '2017-10-27 10:50:54', '2017-10-27 10:51:35', '1', null, null, null, null), ('10059', '水帘洞', '1', '10031', '花果山水帘大道102号', '10028', '10041', '2017-10-27 10:58:06', '2017-10-27 10:58:19', '1', null, null, null, null), ('10060', '白骨洞', '1', '10031', '花果山水帘大道103号', '10041', '10042', '2017-10-27 11:01:53', '2017-10-27 13:17:15', '1', null, null, null, null), ('10061', '黑风洞', '1', '10031', '花果山103号', '10031', '10043', '2017-10-27 11:03:26', '2017-10-27 11:03:56', '1', null, null, null, null), ('10062', '火云洞', '1', '10031', '花果山105号', '10034', '10044', '2017-10-27 11:06:04', '2017-10-27 11:06:44', '1', null, null, null, null), ('10063', '1', '1', '10031', '12', '10038', '10045', '2017-10-27 11:10:58', '2017-10-27 11:13:02', '1', null, null, null, null), ('10064', 'yy的家', '1', '10035', '周雨家', null, '10046', '2017-10-27 11:18:05', '2017-10-27 11:18:10', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_invitation`
-- ----------------------------
DROP TABLE IF EXISTS `app_invitation`;
CREATE TABLE `app_invitation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `landlord_id` int(11) NOT NULL COMMENT '房东ID',
  `user_mobile` varchar(15) NOT NULL COMMENT '被邀请的用户的手机号码',
  `lock_id` int(11) NOT NULL COMMENT '小房间的设备ID',
  `send_invite_time` datetime NOT NULL COMMENT '发出邀请的时间',
  `renting_end_time` datetime NOT NULL COMMENT '租住截止日期',
  `state` int(11) NOT NULL COMMENT '1 未接受邀请 2 已接收邀请',
  `confirm_invite_time` datetime DEFAULT NULL,
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10009 DEFAULT CHARSET=utf8 COMMENT='房东邀请用户入住信息表';

-- ----------------------------
--  Records of `app_invitation`
-- ----------------------------
BEGIN;
INSERT INTO `app_invitation` VALUES ('10001', '10010', '18668165288', '10004', '2017-02-11 00:00:00', '2017-09-22 00:00:00', '2', '2017-10-27 19:05:42', '2017-10-22 21:47:26', '2017-10-27 19:05:42', '1', null, null, null, null), ('10002', '10006', '18668165280', '10000', '2017-02-11 00:00:00', '2017-09-22 00:00:00', '2', null, '2017-10-23 15:43:08', '2017-10-23 15:43:08', '-1', null, null, null, null), ('10003', '10032', '18668165280', '10008', '2017-10-27 00:00:00', '2017-10-28 00:00:00', '2', '2017-10-27 11:23:01', '2017-10-27 11:03:42', '2017-10-27 11:23:01', '1', null, null, null, null), ('10004', '10032', '18668165280', '10008', '2017-10-27 00:00:00', '2017-10-28 00:00:00', '2', '2017-10-27 16:00:08', '2017-10-27 13:05:34', '2017-10-27 16:00:08', '1', null, null, null, null), ('10005', '10032', '18668165280', '10007', '2017-10-27 00:00:00', '2017-10-28 00:00:00', '2', '2017-10-27 16:00:27', '2017-10-27 15:59:39', '2017-10-27 16:00:27', '1', null, null, null, null), ('10007', '10032', '18668165280', '10008', '2017-10-27 00:00:00', '2017-10-28 00:00:00', '2', '2017-10-27 19:07:12', '2017-10-27 19:04:37', '2017-10-27 19:07:12', '1', null, null, null, null), ('10008', '10032', '18668165280', '10008', '2017-02-11 00:00:00', '2017-09-22 00:00:00', '2', '2017-10-31 11:32:28', '2017-10-30 10:06:47', '2017-10-31 11:32:28', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_landlord_auth`
-- ----------------------------
DROP TABLE IF EXISTS `app_landlord_auth`;
CREATE TABLE `app_landlord_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `landlord_id` int(11) NOT NULL COMMENT '房东的ID',
  `huose_id` int(11) NOT NULL COMMENT '授权给用户的房源ID',
  `user_mobile` varchar(15) NOT NULL COMMENT '被授权用户的手机号码',
  `user_tip` varchar(50) NOT NULL COMMENT '被授权用户的备注',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10022 DEFAULT CHARSET=utf8 COMMENT='房东授权管理员信息表';

-- ----------------------------
--  Records of `app_landlord_auth`
-- ----------------------------
BEGIN;
INSERT INTO `app_landlord_auth` VALUES ('10000', '10015', '0', '15257121663', '', null, '2017-10-27 09:22:19', '-1', null, null, null, null), ('10001', '10010', '10016', '18358583827', '18358583827被授权房源信息', null, '2017-10-25 15:40:39', '-1', null, null, null, null), ('10002', '10010', '10017', '18358583827', '18358583827被授权房源信息', null, '2017-10-25 15:42:39', '-1', null, null, null, null), ('10003', '10010', '10018', '18358583827', '18358583827被授权房源信息', null, '2017-10-25 15:42:49', '-1', null, null, null, null), ('10004', '10010', '10019', '18358583827', '18358583827被授权房源信息', null, '2017-10-25 15:47:06', '-1', null, null, null, null), ('10005', '10010', '10020', '18358583827', '18358583827被授权房源信息', null, '2017-10-25 15:47:10', '-1', null, null, null, null), ('10006', '10010', '10016', '18358583827', 'ææç®¡çå', '2017-10-25 15:48:58', '2017-10-25 15:50:25', '-1', null, null, null, null), ('10007', '10010', '10017', '18358583827', 'ææç®¡çå', '2017-10-25 15:48:58', '2017-10-25 15:50:30', '-1', null, null, null, null), ('10008', '10010', '10018', '18358583827', 'ææç®¡çå', '2017-10-25 15:48:58', '2017-10-25 15:50:34', '-1', null, null, null, null), ('10009', '10010', '10019', '18358583827', 'ææç®¡çå', '2017-10-25 15:48:58', '2017-10-25 15:50:39', '-1', null, null, null, null), ('10010', '10010', '10020', '18358583827', 'ææç®¡çå', '2017-10-25 15:48:58', '2017-10-25 15:50:41', '-1', null, null, null, null), ('10016', '10016', '10024', '15257121663', 'sll', '2017-10-26 17:40:20', '2017-10-27 09:22:19', '-1', null, null, null, null), ('10018', '10032', '10025', '18668165280', '1', '2017-10-27 10:20:57', '2017-10-31 12:09:38', '-1', null, null, null, null), ('10019', '10035', '10064', '15257121663', 'sll', '2017-10-27 12:01:11', '2017-10-27 14:10:27', '-1', null, null, null, null), ('10020', '10035', '10064', '15257121663', 'sll', '2017-10-27 14:18:35', '2017-10-27 15:10:55', '-1', null, null, null, null), ('10021', '10032', '10025', '15257121663', 'guanli', '2017-10-27 18:13:04', '2017-10-27 18:13:04', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_lock`
-- ----------------------------
DROP TABLE IF EXISTS `app_lock`;
CREATE TABLE `app_lock` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '锁的ID',
  `house_id` int(11) DEFAULT NULL COMMENT '房源ID',
  `belong_user_id` int(11) NOT NULL COMMENT '设备归属的用户ID，既谁添加的这个设备',
  `name` varchar(20) NOT NULL COMMENT '锁的名称',
  `password` varchar(50) DEFAULT NULL COMMENT '锁默认的开门密码(属于房东管理该设备的永久开门密码)',
  `mac_address` varchar(20) NOT NULL COMMENT '锁的mac地址',
  `room_name` varchar(50) NOT NULL COMMENT '小房间的名称',
  `socket_id` int(11) DEFAULT NULL COMMENT '锁关联的插座ID',
  `open_record_flag` int(1) NOT NULL DEFAULT '1' COMMENT '开门记录上传功能是否开启 1 未开启 2 已开启',
  `fireware_version` varchar(50) NOT NULL COMMENT '锁的固件版本号',
  `max_user_num` int(11) NOT NULL COMMENT '锁的最大用户数',
  `used_user_num` int(11) NOT NULL COMMENT '锁的已用的用户数',
  `battery` varchar(5) DEFAULT NULL COMMENT '电量信息',
  `battery_state` int(1) NOT NULL DEFAULT '1' COMMENT '电量状态 1 正常电量 2 低电量',
  `locked_state` int(1) NOT NULL DEFAULT '1' COMMENT '是否上锁 1 已上锁 2 未上锁',
  `online_state` int(1) NOT NULL DEFAULT '1' COMMENT '是否联网 1 未联网 2 已联网',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10010 DEFAULT CHARSET=utf8 COMMENT='锁具信息表(房源或房间与设备的关联表,添加设备时,房源信息ID或房间信息ID必须至少有一个)';

-- ----------------------------
--  Records of `app_lock`
-- ----------------------------
BEGIN;
INSERT INTO `app_lock` VALUES ('10000', '10010', '10006', '喵喵的锁具', '338785', 'C3:FA:58:31:80:66', 'famng', '1001', '1', 'A0.1.003_20180911', '100', '1', '0', '10', '1', '1', '2017-10-20 15:17:52', '2017-10-22 17:21:14', '1', '', '', '', ''), ('10003', '10013', '10010', 'newlock1111', '11111111111', 'FD:BC:03:8E:D7:11', 'firstRoom', '10004', '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-22 19:30:36', '2017-10-22 19:30:36', '1', null, null, null, null), ('10004', '10013', '10010', 'newlock1222222', '11111111111', 'FD:BC:03:8E:D7:11', 'secondRoom', '10003', '1', 'V0.1.008.20171033', '99', '0', '9999', '1', '1', '1', '2017-10-22 19:30:37', '2017-10-22 19:39:20', '1', null, null, null, null), ('10005', '10025', '10032', 'newlock1111', '111111', 'FD:BC:03:8E:D7:11', 'firstRoom', null, '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-27 10:53:33', '2017-10-31 09:53:59', '1', null, null, null, null), ('10006', '10007', '10032', 'newlock1111', '11111111111', 'FD:BC:03:8E:D7:11', 'firstRoom', null, '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-27 10:56:15', '2017-10-27 10:56:15', '1', null, null, null, null), ('10007', '10025', '10032', 'newlock1111', '11111111111', 'FD:BC:03:8E:D7:11', 'firstRoom', null, '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-27 10:56:58', '2017-10-27 10:56:58', '1', null, null, null, null), ('10008', '10026', '10032', 'newlock1111', '11111111111', 'FD:BC:03:8E:D7:11', 'room1', null, '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-27 10:57:42', '2017-10-27 10:57:42', '1', null, null, null, null), ('10009', '10058', '10031', 'lock', '11111111111', 'FD:BC:03:8E:D7:11', 'room1', null, '1', 'V0.1.008.20171022', '99', '0', '9999', '1', '1', '1', '2017-10-27 18:22:17', '2017-10-30 10:55:01', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_lock_openrecord`
-- ----------------------------
DROP TABLE IF EXISTS `app_lock_openrecord`;
CREATE TABLE `app_lock_openrecord` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '开门记录ID',
  `user_id` int(11) NOT NULL COMMENT '开门的用户ID',
  `open_identify` varchar(50) NOT NULL COMMENT '开门标识，用户指纹和手机开门时为用户ID，密码开门时为固定字符串LOCK-PASSWORD，无法识别时为UNKNOWN',
  `lock_id` int(11) NOT NULL COMMENT '锁的ID',
  `open_type` int(3) NOT NULL DEFAULT '64' COMMENT '开门方式 1 手机 2 指纹 4 密码 128 未知 ',
  `open_time` datetime NOT NULL,
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='开门记录表';

-- ----------------------------
--  Records of `app_lock_openrecord`
-- ----------------------------
BEGIN;
INSERT INTO `app_lock_openrecord` VALUES ('1', '10006', '13757150532', '0', '1', '2017-10-20 15:18:09', '2017-10-20 15:18:09', '2017-10-20 15:18:09', 'C3:FA:58:31:80:65', null, null, null, null), ('2', '10006', '13757150532', '10000', '1', '2017-10-20 15:18:26', '2017-10-20 15:18:26', '2017-10-20 15:18:26', null, null, null, null, null), ('3', '10031', '15257121663', '10009', '1', '2017-10-30 13:10:22', '2017-10-30 13:10:28', '2017-10-30 13:10:36', 'FD:BC:03:8E:D7:11', null, null, null, null), ('4', '10031', '15257121663', '10009', '1', '2017-10-30 13:10:22', '2017-10-30 13:10:28', '2017-10-30 13:10:36', 'FD:BC:03:8E:D7:11', '', '', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `app_lock_temppwd`
-- ----------------------------
DROP TABLE IF EXISTS `app_lock_temppwd`;
CREATE TABLE `app_lock_temppwd` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '临时密码ID',
  `lock_id` int(11) NOT NULL COMMENT '锁的ID',
  `tenant_id` int(11) NOT NULL COMMENT '产生临时密码的租客ID',
  `temp_pwd` varchar(255) NOT NULL COMMENT '单个临时密码',
  `state` int(1) NOT NULL DEFAULT '1' COMMENT '临时密码状态 1 未使用 2 已使用',
  `shared_user_id` int(11) NOT NULL COMMENT '被分享的用户的ID',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10000 DEFAULT CHARSET=utf8 COMMENT='临时密码表';

-- ----------------------------
--  Table structure for `app_lock_tenant`
-- ----------------------------
DROP TABLE IF EXISTS `app_lock_tenant`;
CREATE TABLE `app_lock_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_id` int(11) NOT NULL COMMENT '租客ID',
  `lock_id` int(11) NOT NULL COMMENT '锁ID',
  `check_date` date NOT NULL COMMENT '入住日期',
  `dead_date` date NOT NULL COMMENT '到期日期',
  `rent_days` int(11) NOT NULL COMMENT '租住天数，等于到期日期减去入住日期的时间段换算成的天数',
  `user_lock_password` varchar(50) DEFAULT NULL COMMENT '用户的锁的开锁密码',
  `user_lock_name` varchar(50) NOT NULL COMMENT '用户的锁的名字',
  `user_lock_open_music` int(11) DEFAULT NULL COMMENT '用户的锁的开锁提示音',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL COMMENT '1 状态正常 2 租客已被禁用',
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10021 DEFAULT CHARSET=utf8 COMMENT='租客与设备的关联表';

-- ----------------------------
--  Records of `app_lock_tenant`
-- ----------------------------
BEGIN;
INSERT INTO `app_lock_tenant` VALUES ('10003', '10009', '10004', '2017-03-21', '2017-09-11', '174', '9089089089080', 'lock11111', '11', '2017-10-22 20:42:24', '2017-10-22 21:02:35', '-1', null, null, null, null), ('10004', '10006', '10004', '2017-03-21', '2017-09-11', '174', '9089089089080', 'lock11111', '11', '2017-10-22 20:46:54', '2017-10-22 21:02:34', '1', null, null, null, null), ('10005', '10009', '10004', '2017-03-21', '2017-09-11', '174', '9089089089080', 'lock11111', '11', '2017-10-22 21:03:44', '2017-10-22 21:07:05', '1', null, null, null, null), ('10006', '10005', '10004', '2017-08-01', '2017-09-11', '41', '0000000000000', 'lock2222', '22', '2017-10-22 21:05:07', '2017-10-22 21:09:42', '-1', null, null, null, null), ('10007', '10009', '10004', '2017-03-21', '2017-09-11', '174', '123456', 'lock11111', '11', '2017-10-22 21:21:36', '2017-10-27 16:11:50', '1', null, null, null, null), ('10009', '10005', '10003', '2017-03-21', '2017-09-11', '174', '9089089089080', 'lock11111', '11', '2017-10-22 21:21:48', '2017-10-22 21:21:48', '1', null, null, null, null), ('10010', '10011', '10004', '2017-02-11', '2017-09-22', '223', null, '租客5288', null, '2017-10-22 22:09:46', '2017-10-22 22:09:46', '1', null, null, null, null), ('10011', '10007', '10004', '2017-03-21', '2017-09-11', '174', '9089089089080', 'lock11111', '11', '2017-10-23 10:37:43', '2017-10-23 10:37:43', '1', null, null, null, null), ('10018', '10011', '10004', '2017-02-11', '2017-09-22', '223', null, '租客5288', null, '2017-10-27 19:05:42', '2017-10-27 19:05:42', '1', null, null, null, null), ('10019', '10034', '10008', '2017-10-27', '2017-10-28', '1', null, '租客5280', null, '2017-10-27 19:07:12', '2017-10-27 19:07:12', '-1', null, null, null, null), ('10020', '10034', '10008', '2017-02-11', '2017-09-22', '223', '111222', '租客5280', null, '2017-10-31 11:32:29', '2017-10-31 12:11:48', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_message_code`
-- ----------------------------
DROP TABLE IF EXISTS `app_message_code`;
CREATE TABLE `app_message_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '验证码ID',
  `user_mobile_account` varchar(20) NOT NULL COMMENT '用户手机号码，因为系统用户在注册获取验证码时，系统并没有该用户的信息，不能用用户ID',
  `user_short_num` varchar(20) NOT NULL COMMENT '验证码',
  `msgState` int(11) NOT NULL COMMENT '验证码状态 1 未使用 2 已使用',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(256) DEFAULT NULL,
  `item1` varchar(256) DEFAULT NULL,
  `item2` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='手机获取验证码信息表';

-- ----------------------------
--  Records of `app_message_code`
-- ----------------------------
BEGIN;
INSERT INTO `app_message_code` VALUES ('1', '15257121663', '3863', '2', '2017-10-23 17:09:20', '2017-10-31 09:02:30', '验证验证码', null, null), ('2', '15257121663', '7014', '2', '2017-10-23 17:10:26', '2017-10-31 09:02:30', '验证验证码', null, null), ('3', '18668165280', '8869', '2', '2017-10-24 09:16:17', '2017-10-31 09:02:30', '验证验证码', null, null), ('4', '13738117929', '6267', '2', '2017-10-24 09:23:37', '2017-10-31 09:02:30', '验证验证码', null, null), ('5', '13777556406', '6827', '2', '2017-10-24 09:24:02', '2017-10-31 09:02:30', '验证验证码', null, null), ('6', '15257121663', '8679', '2', '2017-10-24 11:10:32', '2017-10-31 09:02:30', '验证验证码', null, null), ('7', '18668165280', '3090', '2', '2017-10-24 13:01:49', '2017-10-31 09:02:30', '验证验证码', null, null), ('8', '15257121663', '3720', '2', '2017-10-24 13:48:13', '2017-10-31 09:02:30', '验证验证码', null, null), ('9', '15257121663', '9962', '2', '2017-10-24 13:52:55', '2017-10-31 09:02:30', '验证验证码', null, null), ('10', '13757121663', '6878', '2', '2017-10-24 14:03:48', '2017-10-31 09:02:30', '验证验证码', null, null), ('16', '13757150532', '6472', '2', '2017-10-24 16:42:50', '2017-10-31 09:02:30', '验证验证码', null, null), ('17', '13757150539', '1234', '2', '2017-10-24 16:46:31', '2017-10-31 09:02:30', '验证验证码', null, null), ('18', '13777556406', '5219', '2', '2017-10-24 16:48:13', '2017-10-31 09:02:30', '验证验证码', null, null), ('19', '13757150532', '999', '2', '2017-10-24 16:58:32', '2017-10-31 09:02:30', '验证验证码', null, null), ('20', '13757150533', '3125', '2', '2017-10-24 17:14:30', '2017-10-31 09:02:30', '验证验证码', null, null), ('21', '13777556406', '7765', '2', '2017-10-24 17:15:50', '2017-10-31 09:02:30', '验证验证码', null, null), ('22', '15257121663', '9074', '2', '2017-10-25 11:26:15', '2017-10-31 09:02:30', '验证验证码', null, null), ('23', '15257121663', '8636', '2', '2017-10-25 11:27:47', '2017-10-31 09:02:30', '验证验证码', null, null), ('24', '15257121663', '6152', '2', '2017-10-25 11:29:15', '2017-10-31 09:02:30', '验证验证码', null, null), ('25', '15257121663', '3060', '2', '2017-10-25 13:07:57', '2017-10-31 09:02:30', '验证验证码', null, null), ('26', '18358583827', '8785', '2', '2017-10-25 14:14:14', '2017-10-31 09:02:30', '验证验证码', null, null), ('27', '18358583827', '1762', '2', '2017-10-25 14:16:25', '2017-10-31 09:02:30', '验证验证码', null, null), ('28', '13757150532', '7289', '2', '2017-10-26 15:56:36', '2017-10-31 09:02:30', '验证验证码', null, null), ('29', '13777556406', '7525', '2', '2017-10-26 16:01:58', '2017-10-31 09:02:30', '验证验证码', null, null), ('30', '18668165280', '3352', '2', '2017-10-27 08:44:37', '2017-10-31 09:02:30', '验证验证码', null, null), ('31', '18668165280', '4092', '2', '2017-10-27 09:30:37', '2017-10-31 09:02:30', '验证验证码', null, null), ('32', '18668165280', '8609', '2', '2017-10-27 10:19:14', '2017-10-31 09:02:30', '验证验证码', null, null), ('33', '13777556406', '8748', '2', '2017-10-27 11:05:46', '2017-10-31 09:02:30', '验证验证码', null, null), ('34', '13777556406', '3191', '2', '2017-10-27 11:06:58', '2017-10-31 09:02:30', '验证验证码', null, null), ('35', '15257121663', '7590', '2', '2017-10-27 11:30:19', '2017-10-31 09:02:30', '验证验证码', null, null), ('36', '15257121663', '9715', '2', '2017-10-27 11:33:44', '2017-10-31 09:02:30', '验证验证码', null, null), ('37', '15257121663', '3011', '2', '2017-10-27 11:35:46', '2017-10-31 09:02:30', '验证验证码', null, null), ('38', '13777556406', '7886', '2', '2017-10-27 11:36:09', '2017-10-31 09:02:30', '验证验证码', null, null), ('39', '13700000001', '5040', '2', '2017-10-27 11:36:26', '2017-10-31 09:02:30', '验证验证码', null, null), ('40', '13777556406', '5311', '2', '2017-10-27 11:37:17', '2017-10-31 09:02:30', '验证验证码', null, null), ('41', '13757150532', '3552', '2', '2017-10-27 15:56:55', '2017-10-31 09:02:30', '验证验证码', null, null), ('42', '13777556406', '9400', '2', '2017-10-27 15:58:30', '2017-10-31 09:02:30', '验证验证码', null, null), ('43', '13777556406', '5301', '2', '2017-10-30 14:16:02', '2017-10-31 09:02:30', '验证验证码', null, null), ('44', '13777556406', '7613', '2', '2017-10-30 14:17:21', '2017-10-31 09:02:30', '验证验证码', null, null), ('45', '13777556406', '3057', '2', '2017-10-30 17:34:35', '2017-10-31 09:02:30', '验证验证码', null, null), ('46', '13777556406', '1065', '2', '2017-10-31 09:02:26', '2017-10-31 09:02:30', '验证验证码', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_pic`
-- ----------------------------
DROP TABLE IF EXISTS `app_pic`;
CREATE TABLE `app_pic` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '房源图片ID',
  `pic1` varchar(255) DEFAULT NULL,
  `pic2` varchar(255) DEFAULT NULL,
  `pic3` varchar(255) DEFAULT NULL,
  `pic4` varchar(255) DEFAULT NULL,
  `pic5` varchar(255) DEFAULT NULL,
  `pic6` varchar(255) DEFAULT NULL,
  `pic7` varchar(255) DEFAULT NULL,
  `pic8` varchar(255) DEFAULT NULL,
  `pic9` varchar(255) DEFAULT NULL,
  `pic10` varchar(255) DEFAULT NULL,
  `pic11` varchar(255) DEFAULT NULL,
  `pic12` varchar(255) DEFAULT NULL,
  `pic13` varchar(255) DEFAULT NULL,
  `pic14` varchar(255) DEFAULT NULL,
  `pic15` varchar(255) DEFAULT NULL,
  `pic16` varchar(255) DEFAULT NULL,
  `pic17` varchar(255) DEFAULT NULL,
  `pic18` varchar(255) DEFAULT NULL,
  `pic19` varchar(255) DEFAULT NULL,
  `pic20` varchar(255) DEFAULT NULL,
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10042 DEFAULT CHARSET=utf8 COMMENT='房源图片表';

-- ----------------------------
--  Records of `app_pic`
-- ----------------------------
BEGIN;
INSERT INTO `app_pic` VALUES ('10000', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/42906506852760.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10001', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/43239476072112.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10002', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/43570972088647.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10003', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/46206586145721.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10004', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/46360777827662.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10005', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/46869547696571.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10007', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/48659515176247.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10008', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/49633074697073.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10009', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/49775103624862.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/49775863814754.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '-1', null, null, null, null), ('10010', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/50197681414009.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/50198545151704.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/50198985043241.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-19 22:20:36', '2017-10-19 22:20:36', '-1', null, null, null, null), ('10011', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/51045608240342.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/51046398525995.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/51046794005308.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-19 22:34:44', '2017-10-19 22:34:44', '1', null, null, null, null), ('10012', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2578791586659210.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2578792141098186.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2578792696940857.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2578793258334925.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 10:44:33', '2017-10-26 10:44:33', '1', null, null, null, null), ('10013', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2579052279357855.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2579052760721092.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2579053249167050.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2579053799919183.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 10:48:54', '2017-10-26 10:48:54', '1', null, null, null, null), ('10014', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594343294012835.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594343885273471.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594344390360442.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594344970391008.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 15:03:45', '2017-10-26 15:03:45', '1', null, null, null, null), ('10015', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594908028193695.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594908506227743.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594909021919777.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2594909470826329.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 15:13:10', '2017-10-26 15:13:10', '1', null, null, null, null), ('10016', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2595631965201872.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2595632446409661.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2595632984731554.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2595633456647329.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 15:25:14', '2017-10-26 15:25:14', '1', null, null, null, null), ('10017', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2597598412804924.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2597598878236047.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2597599419528537.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2597599972925503.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 15:58:00', '2017-10-26 15:58:00', '1', null, null, null, null), ('10018', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/29532860101100.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/29534133093457.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 16:41:14', '2017-10-26 16:41:14', '1', null, null, null, null), ('10019', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/33941641101232.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 17:54:42', '1', null, null, null, null), ('10020', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/33941641101232.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/34215023375464.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 17:54:42', '2017-10-26 17:59:15', '1', null, null, null, null), ('10021', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/34215023375464.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-26 17:59:15', '1', null, null, null, null), ('10022', null, null, null, null, null, null, null, null, null, null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2659450111399637.png', null, null, null, null, null, null, null, null, '2017-10-27 09:08:51', '2017-10-27 09:08:51', '1', null, null, null, null), ('10023', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2660031063115602.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 09:18:31', '2017-10-27 09:18:31', '1', null, null, null, null), ('10024', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2665614632755463.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 10:51:35', '2017-10-27 10:51:35', '1', null, null, null, null), ('10025', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2679726351746499.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17634397568005.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17636051918710.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17644393903499.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 10:51:35', '2017-10-27 14:46:47', '1', null, null, null, null), ('10026', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2666017837989166.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 10:58:18', '2017-10-27 10:58:18', '1', null, null, null, null), ('10027', null, null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/2666017984275343.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 10:58:18', '2017-10-27 10:58:18', '1', null, null, null, null), ('10028', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/18179723253702.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/18165072791940.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/18166480329021.png', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/18167746259698.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 10:58:19', '2017-10-27 13:35:52', '1', null, null, null, null), ('10029', null, null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9047904796001.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:03:46', '2017-10-27 11:03:46', '1', null, null, null, null), ('10030', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9047904798107.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:03:51', '2017-10-27 11:03:51', '1', null, null, null, null), ('10031', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9054118252627.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:03:56', '2017-10-27 11:03:56', '1', null, null, null, null), ('10032', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9227008716482.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:06:40', '2017-10-27 11:06:40', '1', null, null, null, null), ('10033', null, null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9227327208252.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:06:41', '2017-10-27 11:06:41', '1', null, null, null, null), ('10034', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9228143971412.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:06:44', '2017-10-27 11:06:44', '1', null, null, null, null), ('10035', null, null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9518622600526.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:12:34', '2017-10-27 11:12:34', '1', null, null, null, null), ('10036', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9518622564050.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:12:34', '2017-10-27 11:12:34', '1', null, null, null, null), ('10037', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9518612978584.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:12:37', '2017-10-27 11:12:37', '1', null, null, null, null), ('10038', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/9585670682393.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 11:12:54', '2017-10-27 11:12:51', '1', null, null, null, null), ('10039', null, null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17062622849811.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 13:17:15', '2017-10-27 13:17:15', '1', null, null, null, null), ('10040', 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17062622881098.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 13:17:15', '2017-10-27 13:17:15', '1', null, null, null, null), ('10041', null, 'http://cdn.dsmzg.com:80/upload/debug/userphotos/17062622875597.png', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2017-10-27 13:17:15', '2017-10-27 13:17:15', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_repairs`
-- ----------------------------
DROP TABLE IF EXISTS `app_repairs`;
CREATE TABLE `app_repairs` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '报修ID',
  `tenant_id` int(11) NOT NULL COMMENT '租客ID',
  `landlord_id` int(11) NOT NULL COMMENT '接收保修的房东的ID',
  `lock_id` int(11) NOT NULL COMMENT '报修的设备ID',
  `title` varchar(50) NOT NULL COMMENT '报修标题',
  `content` varchar(800) NOT NULL COMMENT '报修内容',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10007 DEFAULT CHARSET=utf8 COMMENT='租客报修表';

-- ----------------------------
--  Records of `app_repairs`
-- ----------------------------
BEGIN;
INSERT INTO `app_repairs` VALUES ('10002', '10011', '10010', '10004', '11111111', '2222222222222222222222222222222', '2017-10-22 22:25:46', '2017-10-22 22:25:46', '1', null, null, null, null), ('10003', '10011', '10010', '10004', '11111111', '2222222222222222222222222222222', '2017-10-22 22:26:01', '2017-10-22 22:26:01', '1', null, null, null, null), ('10004', '10034', '10032', '10008', '吧', 'undefined', '2017-10-27 15:20:19', '2017-10-27 15:20:19', '1', null, null, null, null), ('10005', '10034', '10032', '10008', '这', 'undefined', '2017-10-27 15:23:47', '2017-10-27 15:23:47', '1', null, null, null, null), ('10006', '10034', '10032', '10008', '标题', '内容', '2017-10-27 15:27:56', '2017-10-27 15:27:56', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_socket`
-- ----------------------------
DROP TABLE IF EXISTS `app_socket`;
CREATE TABLE `app_socket` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '插座ID',
  `manage_user_id` int(11) NOT NULL COMMENT '添加插座的用户ID',
  `house_id` int(11) DEFAULT NULL COMMENT '插头关联的房源ID',
  `name` varchar(50) NOT NULL COMMENT '插座名称',
  `mac` varchar(20) NOT NULL COMMENT '插座mac地址',
  `wifi_ssid` varchar(50) DEFAULT NULL,
  `wifi_password` varchar(50) DEFAULT NULL,
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10008 DEFAULT CHARSET=utf8 COMMENT='插座表';

-- ----------------------------
--  Records of `app_socket`
-- ----------------------------
BEGIN;
INSERT INTO `app_socket` VALUES ('10001', '10006', null, '陈苗发的插头', 'C3:FA:58:31:80:65', 'chairman', '13757150354', '2017-10-20 15:07:07', '2017-10-22 17:21:14', '-1', null, null, null, null), ('10002', '10010', null, 'socket1111', 'CE:9F:5F:69:92:15', 'xiaomi89e6', 'addddkkkk', '2017-10-22 17:33:12', '2017-10-22 18:00:02', '-1', null, null, null, null), ('10003', '10010', null, 'socket11199999999999', 'CE:9F:5F:69:92:15', 'xiaomi89e600000000000', 'HHHHHHHHHHHHHH', '2017-10-22 17:45:56', '2017-10-22 18:13:43', '1', null, null, null, null), ('10004', '10010', null, 'socket2222', 'CE:9F:5F:69:92:44', 'aaa', 'bbb', '2017-10-22 18:17:15', '2017-10-22 19:39:20', '-1', null, null, null, null), ('10005', '10010', null, 'wwwwwwwww', 'F5:77:D1:86:90:74', '99999999', '999999999999999', '2017-10-22 18:32:02', '2017-10-22 18:35:42', '-1', null, null, null, null), ('10006', '10010', null, 'ggggggggg', 'F5:77:D1:86:90:74', '99999999', '999999999999999', '2017-10-24 11:10:56', '2017-10-24 11:16:15', '1', null, null, null, null), ('10007', '10032', null, 'mac', '啊', '123', '', '2017-10-25 15:04:48', '2017-10-25 15:04:48', '1', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `app_sys_role`;
CREATE TABLE `app_sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `name` varchar(20) NOT NULL COMMENT '角色名称',
  `type` int(3) NOT NULL DEFAULT '1' COMMENT '角色类型 -1未知角色 1 系统用户 2 租客 4 房东 8 既是房东又是租客 16 安装人员  32 房东授权的管理员',
  `remark` varchar(20) DEFAULT NULL COMMENT '角色备注',
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10033 DEFAULT CHARSET=utf8 COMMENT='用户角色表';

-- ----------------------------
--  Records of `app_sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `app_sys_role` VALUES ('10027', '系统用户', '1', '添加角色', '2017-10-25 08:34:10', '2017-10-25 08:34:10'), ('10028', '租客', '2', '添加角色', '2017-10-25 08:34:10', '2017-10-25 08:34:10'), ('10029', '房东', '4', '添加角色', '2017-10-25 08:34:10', '2017-10-25 08:34:10'), ('10031', '安装工人', '16', '添加角色', '2017-10-25 08:34:10', '2017-10-25 08:34:10'), ('10032', '房东授权的管理员', '32', '添加角色', '2017-10-25 08:34:10', '2017-10-25 08:34:10');
COMMIT;

-- ----------------------------
--  Table structure for `app_sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `app_sys_user`;
CREATE TABLE `app_sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `mobile` varchar(15) NOT NULL COMMENT '手机号码',
  `wechat_open_id` varchar(100) NOT NULL COMMENT '微信openid',
  `qq` varchar(20) DEFAULT NULL COMMENT 'QQ号码',
  `nick_name` varchar(20) DEFAULT NULL COMMENT '用户昵称',
  `photo` varchar(255) DEFAULT NULL COMMENT '用户图像',
  `password` varchar(128) DEFAULT NULL COMMENT '用户密码，建议至少MD5加密',
  `email` varchar(50) DEFAULT NULL COMMENT '用户邮箱',
  `birthday` date DEFAULT NULL COMMENT '用户生日',
  `state` int(3) NOT NULL DEFAULT '1' COMMENT '用户状态 1 正常 2 已禁用 4 已删除',
  `insert_time` datetime DEFAULT NULL COMMENT '记录插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '记录更新时间',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  `item3` varchar(50) DEFAULT NULL,
  `item4` varchar(50) DEFAULT NULL,
  `item5` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10040 DEFAULT CHARSET=utf8 COMMENT='系统用户表';

-- ----------------------------
--  Records of `app_sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `app_sys_user` VALUES ('10006', '13757150533', '', '', '用户0532', '', '', '', '0000-00-00', '1', '2017-10-19 16:45:35', '2017-10-19 16:45:35', '绑定微信账号', '1', '', '', '', ''), ('10007', '18668165299', 'wechat000022222k', null, '用户5299', null, null, null, null, '1', '2017-10-21 14:01:07', '2017-10-21 14:01:07', '绑定微信账号', '1', null, null, null, null), ('10008', '18668162222', 'wechat00002', null, '用户2222', null, null, null, null, '1', '2017-10-21 14:31:05', '2017-10-21 14:31:05', '更新微信账号', '1', null, null, null, null), ('10009', '18668162223', 'wechat00002', null, '用户2223', null, null, null, null, '1', '2017-10-21 14:31:26', '2017-10-21 14:31:26', '绑定微信账号', '1', null, null, null, null), ('10010', '13738117929', 'wechat00000000000000000000', null, '用户7929', null, null, null, null, '1', '2017-10-22 16:55:36', '2017-10-22 16:55:36', '绑定微信账号', '1', null, null, null, null), ('10011', '18668165288', 'wechat000033300000000000000', null, '用户5288', null, null, null, null, '1', '2017-10-22 22:00:57', '2017-10-22 22:00:57', '绑定微信账号', '1', null, null, null, null), ('10013', '13738119999', 'wechat00088888888', null, '用户9999', null, null, null, null, '1', '2017-10-23 10:43:30', '2017-10-23 10:43:30', '绑定微信账号', '1', null, null, null, null), ('10031', '15257121663', 'odRMC0Y_0jdyoPpp7gjBKBPfEV7g', null, '用户1663', null, null, null, null, '1', '2017-10-25 13:08:03', '2017-10-25 13:08:03', '绑定微信账号', '1', null, null, null, null), ('10032', '18358583827', 'odRMC0fBSvcev8qan8PyYjbifPeY', null, '用户3827', null, null, null, null, '1', '2017-10-25 14:16:36', '2017-10-25 14:16:36', '绑定微信账号', '1', null, null, null, null), ('10034', '18668165280', 'odRMC0bTLNeTMjISC4eoV2mMZCz0', null, '用户5280', null, null, null, null, '1', '2017-10-27 10:19:25', '2017-10-27 10:19:25', '绑定微信账号', null, null, null, null, null), ('10035', '13777556406', 'odRMC0VcB2C8zlAWHo542sI_nOuQ', null, '用户6406', null, null, null, null, '-1', '2017-10-27 11:07:05', '2017-10-27 11:07:05', '绑定微信账号', null, null, null, null, null), ('10036', '13757150532', '', null, '陈苗发', null, null, null, null, '1', null, null, null, null, null, null, null, null), ('10038', '13777556406', 'odRMC0VcB2C8zlAWHo542sI_nOuQ', null, '用户6406', null, null, null, null, '-1', '2017-10-30 14:16:09', '2017-10-30 14:16:09', '绑定微信账号', null, null, null, null, null), ('10039', '13777556406', 'odRMC0VcB2C8zlAWHo542sI_nOuQ', null, '用户6406', 'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJysPlryZUE2YJIHXX7y8jeXUTDdvUiaxqKm9TkdkKRYh0KicD7B9pKgjPibaLUqjINvPQ6toRziamIIA/0', null, null, null, '1', '2017-10-30 14:17:25', '2017-10-30 14:17:25', '绑定微信账号', null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `app_sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `app_sys_user_role`;
CREATE TABLE `app_sys_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户角色关联ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `role_id` int(11) NOT NULL,
  `insert_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item1` varchar(50) DEFAULT NULL,
  `item2` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10056 DEFAULT CHARSET=utf8 COMMENT='用户与角色关联表';

-- ----------------------------
--  Records of `app_sys_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `app_sys_user_role` VALUES ('10003', '10004', '10027', '2017-10-19 15:23:21', '2017-10-19 16:35:01', '1', null), ('10005', '10006', '10027', '2017-10-20 15:25:02', '2017-10-22 21:02:34', '1', ''), ('10006', '10009', '10028', '2017-10-21 14:32:05', '2017-10-22 21:21:35', '1', null), ('10007', '10010', '10027', '2017-10-22 16:55:36', '2017-10-22 17:32:58', '1', null), ('10008', '10011', '10028', '2017-10-22 22:00:57', '2017-10-22 22:09:46', '1', null), ('10009', '10007', '10028', '2017-10-23 10:32:00', '2017-10-23 10:37:43', '1', null), ('10010', '10008', '10027', '2017-10-23 10:32:22', '2017-10-23 10:32:24', '1', null), ('10011', '10012', '10027', '2017-10-23 10:39:11', '2017-10-23 10:39:11', '1', null), ('10014', '10016', '10027', '2017-10-24 09:24:06', '2017-10-24 09:24:06', '1', null), ('10029', '10031', '10027', '2017-10-25 13:08:03', '2017-10-25 13:08:03', '1', null), ('10030', '10032', '10027', '2017-10-25 14:16:36', '2017-10-25 14:16:36', '1', null), ('10031', '10010', '10029', '2017-10-25 15:04:05', '2017-10-25 15:04:05', '1', null), ('10032', '10032', '10032', '2017-10-25 15:22:10', '2017-10-25 15:47:10', '-1', null), ('10033', '10032', '10032', '2017-10-25 15:48:58', '2017-10-25 15:50:39', '-1', null), ('10034', '10032', '10032', '2017-10-25 15:50:58', '2017-10-26 18:27:35', '-1', null), ('10035', '10031', '10029', '2017-10-26 10:40:26', '2017-10-26 10:40:26', '1', null), ('10036', '10016', '10029', '2017-10-26 14:33:25', '2017-10-26 14:33:25', '1', null), ('10037', '10032', '10029', '2017-10-26 15:01:36', '2017-10-26 15:01:36', '1', null), ('10038', '10031', '10032', '2017-10-26 17:40:20', '2017-10-27 09:22:19', '-1', null), ('10039', '10004', '10032', '2017-10-27 09:23:59', '2017-10-27 09:24:18', '-1', null), ('10041', '10034', '10027', '2017-10-27 10:19:25', '2017-10-27 10:19:25', '1', null), ('10042', '10034', '10032', '2017-10-27 10:20:57', '2017-10-31 12:09:38', '-1', null), ('10043', '10032', '10031', '2017-10-27 10:53:22', '2017-10-27 10:53:24', '1', null), ('10044', '10035', '10027', '2017-10-27 11:07:05', '2017-10-27 11:07:05', '-1', null), ('10045', '10035', '10029', '2017-10-27 11:18:05', '2017-10-27 11:18:05', '-1', null), ('10046', '10034', '10028', '2017-10-27 11:22:55', '2017-10-27 13:03:16', '-1', null), ('10047', '10031', '10032', '2017-10-27 12:01:11', '2017-10-27 14:10:28', '-1', null), ('10048', '10034', '10028', '2017-10-27 13:08:24', '2017-10-27 13:08:24', '1', null), ('10049', '10031', '10032', '2017-10-27 14:18:35', '2017-10-27 15:10:55', '-1', null), ('10050', '10037', '10027', '2017-10-27 15:58:42', '2017-10-27 15:58:42', '1', null), ('10051', '10031', '10028', '2017-10-27 18:10:32', '2017-10-27 18:10:32', '1', null), ('10052', '10031', '10032', '2017-10-27 18:13:04', '2017-10-27 18:13:04', '1', null), ('10053', '10031', '10031', '2017-10-27 18:13:04', '2017-10-27 18:13:04', '1', null), ('10054', '10038', '10027', '2017-10-30 14:16:09', '2017-10-30 14:16:09', '-1', null), ('10055', '10039', '10027', '2017-10-30 14:17:26', '2017-10-30 14:17:26', '1', null);
COMMIT;

-- ----------------------------
--  Table structure for `qrtz_blob_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_calendars`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_cron_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qrtz_cron_triggers`
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai'), ('RenrenScheduler', 'TASK_2', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
--  Table structure for `qrtz_fired_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_job_details`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qrtz_job_details`
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', null, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000d4a4f425f504152414d5f4b45597400b67b226a6f624964223a312c226265616e4e616d65223a22746573745461736b222c226d6574686f644e616d65223a2274657374222c22706172616d73223a2272656e72656e222c2263726f6e45787072657373696f6e223a223020302f3330202a202a202a203f222c22737461747573223a302c2272656d61726b223a22e69c89e58f82e695b0e6b58be8af95222c2263726561746554696d65223a2244656320312c20323031362031313a31363a343620504d227d7800), ('RenrenScheduler', 'TASK_2', 'DEFAULT', null, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000d4a4f425f504152414d5f4b45597400a47b226a6f624964223a322c226265616e4e616d65223a22746573745461736b222c226d6574686f644e616d65223a227465737432222c2263726f6e45787072657373696f6e223a223020302f3330202a202a202a203f222c22737461747573223a312c2272656d61726b223a22e697a0e58f82e695b0e6b58be8af95222c2263726561746554696d65223a2244656320332c203230313620323a35353a353620504d227d7800);
COMMIT;

-- ----------------------------
--  Table structure for `qrtz_locks`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qrtz_locks`
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS'), ('RenrenScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
--  Table structure for `qrtz_paused_trigger_grps`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_scheduler_state`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qrtz_scheduler_state`
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'iZbp10rtmlr71ju32fzvyaZ1509420504215', '1509428356456', '15000');
COMMIT;

-- ----------------------------
--  Table structure for `qrtz_simple_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_simprop_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `qrtz_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qrtz_triggers`
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_1', 'DEFAULT', 'TASK_1', 'DEFAULT', null, '1509429600000', '1509427800000', '5', 'WAITING', 'CRON', '1508228491000', '0', null, '2', 0xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000d4a4f425f504152414d5f4b45597400b67b226a6f624964223a312c226265616e4e616d65223a22746573745461736b222c226d6574686f644e616d65223a2274657374222c22706172616d73223a2272656e72656e222c2263726f6e45787072657373696f6e223a223020302f3330202a202a202a203f222c22737461747573223a302c2272656d61726b223a22e69c89e58f82e695b0e6b58be8af95222c2263726561746554696d65223a2244656320312c20323031362031313a31363a343620504d227d7800), ('RenrenScheduler', 'TASK_2', 'DEFAULT', 'TASK_2', 'DEFAULT', null, '1508229000000', '-1', '5', 'PAUSED', 'CRON', '1508228491000', '0', null, '2', 0xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c7708000000100000000174000d4a4f425f504152414d5f4b45597400a47b226a6f624964223a322c226265616e4e616d65223a22746573745461736b222c226d6574686f644e616d65223a227465737432222c2263726f6e45787072657373696f6e223a223020302f3330202a202a202a203f222c22737461747573223a312c2272656d61726b223a22e697a0e58f82e695b0e6b58be8af95222c2263726561746554696d65223a2244656320332c203230313620323a35353a353620504d227d7800);
COMMIT;

-- ----------------------------
--  Table structure for `schedule_job`
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(4) DEFAULT NULL COMMENT '任务状态  0：正常  1：暂停',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='定时任务';

-- ----------------------------
--  Records of `schedule_job`
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job` VALUES ('1', 'testTask', 'test', 'renren', '0 0/30 * * * ?', '0', '有参数测试', '2016-12-01 23:16:46'), ('2', 'testTask', 'test2', null, '0 0/30 * * * ?', '1', '无参数测试', '2016-12-03 14:55:56');
COMMIT;

-- ----------------------------
--  Table structure for `schedule_job_log`
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务日志id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '方法名',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(4) NOT NULL COMMENT '任务状态    0：成功    1：失败',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `job_id` (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=631 DEFAULT CHARSET=utf8 COMMENT='定时任务日志';

-- ----------------------------
--  Records of `schedule_job_log`
-- ----------------------------
BEGIN;
INSERT INTO `schedule_job_log` VALUES ('1', '1', 'testTask', 'test', 'renren', '0', null, '1047', '2017-10-17 17:00:00'), ('2', '1', 'testTask', 'test', 'renren', '0', null, '1061', '2017-10-17 17:30:00'), ('3', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-17 18:00:00'), ('4', '1', 'testTask', 'test', 'renren', '0', null, '1018', '2017-10-17 18:30:00'), ('5', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-17 19:00:00'), ('6', '1', 'testTask', 'test', 'renren', '0', null, '1018', '2017-10-17 19:30:00'), ('7', '1', 'testTask', 'test', 'renren', '0', null, '1050', '2017-10-18 09:30:00'), ('8', '1', 'testTask', 'test', 'renren', '0', null, '1038', '2017-10-18 10:00:00'), ('9', '1', 'testTask', 'test', 'renren', '0', null, '1062', '2017-10-18 11:00:00'), ('10', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-18 11:30:00'), ('11', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-18 12:00:00'), ('12', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-18 12:30:00'), ('13', '1', 'testTask', 'test', 'renren', '0', null, '1064', '2017-10-18 13:00:00'), ('14', '1', 'testTask', 'test', 'renren', '0', null, '1074', '2017-10-18 13:30:00'), ('15', '1', 'testTask', 'test', 'renren', '0', null, '1056', '2017-10-18 14:00:00'), ('16', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-18 14:30:00'), ('17', '1', 'testTask', 'test', 'renren', '0', null, '1061', '2017-10-18 15:00:00'), ('18', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-18 15:30:00'), ('19', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-18 16:00:00'), ('20', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-18 16:30:00'), ('21', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-18 17:00:00'), ('22', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-18 17:30:00'), ('23', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-18 18:00:00'), ('24', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-18 18:30:00'), ('25', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-18 19:00:00'), ('26', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-18 19:30:00'), ('27', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-18 20:00:00'), ('28', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-18 20:30:00'), ('29', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-18 21:00:00'), ('30', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-18 21:30:00'), ('31', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-18 22:00:00'), ('32', '1', 'testTask', 'test', 'renren', '0', null, '1019', '2017-10-18 22:30:00'), ('33', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-18 23:00:00'), ('34', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-18 23:30:00'), ('35', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-19 00:00:00'), ('36', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-19 00:30:00'), ('37', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-19 01:00:00'), ('38', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-19 01:30:00'), ('39', '1', 'testTask', 'test', 'renren', '0', null, '1004', '2017-10-19 02:00:00'), ('40', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-19 02:30:00'), ('41', '1', 'testTask', 'test', 'renren', '0', null, '1024', '2017-10-19 03:00:00'), ('42', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-19 03:30:00'), ('43', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-19 04:00:00'), ('44', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 04:30:00'), ('45', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 05:00:00'), ('46', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-19 05:30:00'), ('47', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 06:00:00'), ('48', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 06:30:00'), ('49', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 07:00:00'), ('50', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 07:30:00'), ('51', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 08:00:00'), ('52', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 08:30:00'), ('53', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 09:00:00'), ('54', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 09:30:00'), ('55', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 10:00:00'), ('56', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-19 10:30:00'), ('57', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 11:00:00'), ('58', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 11:30:00'), ('59', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 12:00:00'), ('60', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 12:30:00'), ('61', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 13:00:00'), ('62', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-19 13:30:00'), ('63', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 14:00:00'), ('64', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-19 14:30:00'), ('65', '1', 'testTask', 'test', 'renren', '0', null, '1056', '2017-10-19 15:00:00'), ('66', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 15:30:00'), ('67', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-19 16:00:00'), ('68', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 16:30:00'), ('69', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 17:00:00'), ('70', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 17:30:00'), ('71', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-19 18:00:00'), ('72', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-19 18:30:00'), ('73', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-19 19:00:00'), ('74', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-19 19:30:00'), ('75', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 20:00:00'), ('76', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-19 20:30:00'), ('77', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 21:00:00'), ('78', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-19 21:30:00'), ('79', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-19 22:00:00'), ('80', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-19 22:30:00'), ('81', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 23:00:00'), ('82', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-19 23:30:00'), ('83', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-20 00:00:00'), ('84', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 00:30:00'), ('85', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 01:00:00'), ('86', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 01:30:00'), ('87', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 02:00:00'), ('88', '1', 'testTask', 'test', 'renren', '0', null, '1016', '2017-10-20 02:30:00'), ('89', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 03:00:00'), ('90', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-20 03:30:00'), ('91', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-20 04:00:00'), ('92', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 04:30:00'), ('93', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-20 05:00:00'), ('94', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 05:30:00'), ('95', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-20 06:00:00'), ('96', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 06:30:00'), ('97', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 07:00:00'), ('98', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 07:30:00'), ('99', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 08:00:00'), ('100', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 08:30:00'), ('101', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 09:00:00'), ('102', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-20 09:30:00'), ('103', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 10:00:00'), ('104', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 10:30:00'), ('105', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-20 11:00:00'), ('106', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-20 11:30:00'), ('107', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 12:00:00'), ('108', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 12:30:00'), ('109', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-20 13:00:00'), ('110', '1', 'testTask', 'test', 'renren', '0', null, '1019', '2017-10-20 13:30:00'), ('111', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-20 14:00:00'), ('112', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 14:30:00'), ('113', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 15:00:00'), ('114', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 15:30:00'), ('115', '1', 'testTask', 'test', 'renren', '0', null, '1064', '2017-10-20 16:00:00'), ('116', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-20 16:30:00'), ('117', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-20 17:00:00'), ('118', '1', 'testTask', 'test', 'renren', '0', null, '1015', '2017-10-20 17:30:00'), ('119', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 18:00:00'), ('120', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 18:30:00'), ('121', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-20 19:00:00'), ('122', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-20 19:30:00'), ('123', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 20:00:00'), ('124', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 20:30:00'), ('125', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 21:00:00'), ('126', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 21:30:00'), ('127', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-20 22:00:00'), ('128', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-20 22:30:00'), ('129', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-20 23:00:00'), ('130', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-20 23:30:00'), ('131', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 00:00:00'), ('132', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-21 00:30:00'), ('133', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 01:00:00'), ('134', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-21 01:30:00'), ('135', '1', 'testTask', 'test', 'renren', '0', null, '1016', '2017-10-21 02:00:00'), ('136', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 02:30:00'), ('137', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 03:00:00'), ('138', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 03:30:00'), ('139', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 04:00:00'), ('140', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 04:30:00'), ('141', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 05:00:00'), ('142', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-21 05:30:00'), ('143', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 06:00:00'), ('144', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 06:30:00'), ('145', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 07:00:00'), ('146', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-21 07:30:00'), ('147', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 08:00:00'), ('148', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 08:30:00'), ('149', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 09:00:00'), ('150', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 09:30:00'), ('151', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 10:00:00'), ('152', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 10:30:00'), ('153', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-21 11:00:00'), ('154', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 11:30:00'), ('155', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 12:00:00'), ('156', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 12:30:00'), ('157', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 13:00:00'), ('158', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-21 13:30:00'), ('159', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 14:00:00'), ('160', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 14:30:00'), ('161', '1', 'testTask', 'test', 'renren', '0', null, '1061', '2017-10-21 15:00:00'), ('162', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 15:30:00'), ('163', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-21 16:00:00'), ('164', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 16:30:00'), ('165', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-21 17:00:00'), ('166', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 17:30:00'), ('167', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-21 18:00:00'), ('168', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-21 18:30:00'), ('169', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 19:00:00'), ('170', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 19:30:00'), ('171', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 20:00:00'), ('172', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-21 20:30:00'), ('173', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 21:00:00'), ('174', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-21 21:30:00'), ('175', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-21 22:00:00'), ('176', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-21 22:30:00'), ('177', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-21 23:00:00'), ('178', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-21 23:30:00'), ('179', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 00:00:00'), ('180', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 00:30:00'), ('181', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 01:00:00'), ('182', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 01:30:00'), ('183', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 02:00:00'), ('184', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 02:30:00'), ('185', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 03:00:00'), ('186', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-22 03:30:00'), ('187', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-22 04:00:00'), ('188', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 04:30:00'), ('189', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-22 05:00:00'), ('190', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-22 05:30:00'), ('191', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 06:00:00'), ('192', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 06:30:00'), ('193', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 07:00:00'), ('194', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 07:30:00'), ('195', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 08:00:00'), ('196', '1', 'testTask', 'test', 'renren', '0', null, '1060', '2017-10-22 08:30:00'), ('197', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 09:00:00'), ('198', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 09:30:00'), ('199', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 10:00:00'), ('200', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 10:30:00'), ('201', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-22 11:00:00'), ('202', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-22 11:30:00'), ('203', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 12:00:00'), ('204', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-22 12:30:00'), ('205', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-22 13:00:00'), ('206', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 13:30:00'), ('207', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 14:00:00'), ('208', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 14:30:00'), ('209', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-22 15:00:00'), ('210', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 15:30:00'), ('211', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 16:00:00'), ('212', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 16:30:00'), ('213', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 17:00:00'), ('214', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 17:30:00'), ('215', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-22 18:00:00'), ('216', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-22 18:30:00'), ('217', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 19:00:00'), ('218', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 19:30:00'), ('219', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 20:00:00'), ('220', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-22 20:30:00'), ('221', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 21:00:00'), ('222', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 21:30:00'), ('223', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 22:00:00'), ('224', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-22 22:30:00'), ('225', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-22 23:00:00'), ('226', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-22 23:30:00'), ('227', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 00:00:00'), ('228', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 00:30:00'), ('229', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 01:00:00'), ('230', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 01:30:00'), ('231', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 02:00:00'), ('232', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 02:30:00'), ('233', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 03:00:00'), ('234', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 03:30:00'), ('235', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 04:00:00'), ('236', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-23 04:30:00'), ('237', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-23 05:00:00'), ('238', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 05:30:00'), ('239', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 06:00:00'), ('240', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 06:30:00'), ('241', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 07:00:00'), ('242', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 07:30:00'), ('243', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-23 08:00:00'), ('244', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-23 08:30:00'), ('245', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 09:00:00'), ('246', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 09:30:00'), ('247', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-23 10:00:00'), ('248', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 10:30:00'), ('249', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 11:00:00'), ('250', '1', 'testTask', 'test', 'renren', '0', null, '1071', '2017-10-23 11:30:00'), ('251', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-23 12:00:00'), ('252', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-23 12:30:00'), ('253', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 13:00:00'), ('254', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 13:30:00'), ('255', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 14:00:00'), ('256', '1', 'testTask', 'test', 'renren', '0', null, '1056', '2017-10-23 14:30:00'), ('257', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-23 15:00:00'), ('258', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 15:30:00'), ('259', '1', 'testTask', 'test', 'renren', '0', null, '1088', '2017-10-23 16:00:00'), ('260', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-23 16:30:00'), ('261', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-23 17:00:00'), ('262', '1', 'testTask', 'test', 'renren', '0', null, '1070', '2017-10-23 18:00:00'), ('263', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 18:30:00'), ('264', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 19:00:00'), ('265', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 19:30:00'), ('266', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 20:00:00'), ('267', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 20:30:00'), ('268', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 21:00:00'), ('269', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 21:30:00'), ('270', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-23 22:00:00'), ('271', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-23 22:30:00'), ('272', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-23 23:00:00'), ('273', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-23 23:30:00'), ('274', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-24 00:00:00'), ('275', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 00:30:00'), ('276', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 01:00:00'), ('277', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-24 01:30:00'), ('278', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 02:00:00'), ('279', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-24 02:30:00'), ('280', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 03:00:00'), ('281', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 03:30:00'), ('282', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 04:00:00'), ('283', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 04:30:00'), ('284', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 05:00:00'), ('285', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 05:30:00'), ('286', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 06:00:00'), ('287', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-24 06:30:00'), ('288', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-24 07:00:00'), ('289', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-24 07:30:00'), ('290', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-24 08:00:00'), ('291', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-24 08:30:00'), ('292', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 09:00:00'), ('293', '1', 'testTask', 'test', 'renren', '0', null, '1068', '2017-10-24 09:30:00'), ('294', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-24 10:00:00'), ('295', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 10:30:00'), ('296', '1', 'testTask', 'test', 'renren', '0', null, '1018', '2017-10-24 11:00:00'), ('297', '1', 'testTask', 'test', 'renren', '0', null, '1072', '2017-10-24 12:00:00'), ('298', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-24 12:30:00'), ('299', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-24 13:00:00'), ('300', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 13:30:00'), ('301', '1', 'testTask', 'test', 'renren', '0', null, '1070', '2017-10-24 14:00:00'), ('302', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 14:30:00'), ('303', '1', 'testTask', 'test', 'renren', '0', null, '1056', '2017-10-24 15:00:00'), ('304', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 15:30:00'), ('305', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 16:00:00'), ('306', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-24 16:30:00'), ('307', '1', 'testTask', 'test', 'renren', '0', null, '1068', '2017-10-24 17:00:00'), ('308', '1', 'testTask', 'test', 'renren', '0', null, '1064', '2017-10-24 17:30:00'), ('309', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-24 18:00:00'), ('310', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-24 18:30:00'), ('311', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 19:00:00'), ('312', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 19:30:00'), ('313', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 20:00:00'), ('314', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 20:30:00'), ('315', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-24 21:00:00'), ('316', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-24 21:30:00'), ('317', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 22:00:00'), ('318', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-24 22:30:00'), ('319', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 23:00:00'), ('320', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-24 23:30:00'), ('321', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 00:00:00'), ('322', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 00:30:00'), ('323', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 01:00:00'), ('324', '1', 'testTask', 'test', 'renren', '0', null, '1018', '2017-10-25 01:30:00'), ('325', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 02:00:00'), ('326', '1', 'testTask', 'test', 'renren', '0', null, '1015', '2017-10-25 02:30:00'), ('327', '1', 'testTask', 'test', 'renren', '0', null, '1023', '2017-10-25 03:00:00'), ('328', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 03:30:00'), ('329', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 04:00:00'), ('330', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 04:30:00'), ('331', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-25 05:00:00'), ('332', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 05:30:00'), ('333', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 06:00:00'), ('334', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 06:30:00'), ('335', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-25 07:00:00'), ('336', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 07:30:00'), ('337', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 08:00:00'), ('338', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-25 08:30:00'), ('339', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 09:00:00'), ('340', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-25 09:30:00'), ('341', '1', 'testTask', 'test', 'renren', '0', null, '1062', '2017-10-25 10:30:00'), ('342', '1', 'testTask', 'test', 'renren', '0', null, '1057', '2017-10-25 11:30:00'), ('343', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 12:00:00'), ('344', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-25 12:30:00'), ('345', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 13:00:00'), ('346', '1', 'testTask', 'test', 'renren', '0', null, '1065', '2017-10-25 13:30:00'), ('347', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 14:00:00'), ('348', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-25 14:30:00'), ('349', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 15:00:00'), ('350', '1', 'testTask', 'test', 'renren', '0', null, '1066', '2017-10-25 15:30:00'), ('351', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-25 16:00:00'), ('352', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 16:30:00'), ('353', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 17:00:00'), ('354', '1', 'testTask', 'test', 'renren', '0', null, '1015', '2017-10-25 17:30:00'), ('355', '1', 'testTask', 'test', 'renren', '0', null, '1053', '2017-10-25 18:00:00'), ('356', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-25 18:30:00'), ('357', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 19:00:00'), ('358', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 19:30:00'), ('359', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-25 20:00:00'), ('360', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 20:30:00'), ('361', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 21:00:00'), ('362', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 21:30:00'), ('363', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-25 22:00:00'), ('364', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 22:30:00'), ('365', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 23:00:00'), ('366', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-25 23:30:00'), ('367', '1', 'testTask', 'test', 'renren', '0', null, '1019', '2017-10-26 00:00:00'), ('368', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 00:30:00'), ('369', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 01:00:00'), ('370', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-26 01:30:00'), ('371', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 02:00:00'), ('372', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-26 02:30:00'), ('373', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 03:00:00'), ('374', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-26 03:30:00'), ('375', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 04:00:00'), ('376', '1', 'testTask', 'test', 'renren', '0', null, '1020', '2017-10-26 04:30:00'), ('377', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-26 05:00:00'), ('378', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-26 05:30:00'), ('379', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 06:00:00'), ('380', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-26 06:30:00'), ('381', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-26 07:00:00'), ('382', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-26 07:30:00'), ('383', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 08:00:00'), ('384', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 08:30:00'), ('385', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-26 09:00:00'), ('386', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-26 09:30:00'), ('387', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 10:00:00'), ('388', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 10:30:00'), ('389', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 11:00:00'), ('390', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-26 11:30:00'), ('391', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 12:00:00'), ('392', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-26 12:30:00'), ('393', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-26 13:00:00'), ('394', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 13:30:00'), ('395', '1', 'testTask', 'test', 'renren', '0', null, '1024', '2017-10-26 14:00:00'), ('396', '1', 'testTask', 'test', 'renren', '0', null, '1019', '2017-10-26 14:30:00'), ('397', '1', 'testTask', 'test', 'renren', '0', null, '1062', '2017-10-26 15:30:00'), ('398', '1', 'testTask', 'test', 'renren', '0', null, '1061', '2017-10-26 16:30:00'), ('399', '1', 'testTask', 'test', 'renren', '0', null, '1054', '2017-10-26 17:00:00'), ('400', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-26 17:30:00'), ('401', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-26 18:00:00'), ('402', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 18:30:00'), ('403', '1', 'testTask', 'test', 'renren', '0', null, '1058', '2017-10-26 19:00:00'), ('404', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-26 19:30:00'), ('405', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 20:00:00'), ('406', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 20:30:00'), ('407', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-26 21:00:00'), ('408', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 21:30:00'), ('409', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-26 22:00:00'), ('410', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 22:30:00'), ('411', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-26 23:00:00'), ('412', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-26 23:30:00'), ('413', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 00:00:00'), ('414', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 00:30:00'), ('415', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-27 01:00:00'), ('416', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 01:30:00'), ('417', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 02:00:00'), ('418', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-27 02:30:00'), ('419', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-27 03:00:00'), ('420', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-27 03:30:00'), ('421', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 04:00:00'), ('422', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-27 04:30:00'), ('423', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-27 05:00:00'), ('424', '1', 'testTask', 'test', 'renren', '0', null, '1015', '2017-10-27 05:30:00'), ('425', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 06:00:00'), ('426', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 06:30:00'), ('427', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-27 07:00:00'), ('428', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 07:30:00'), ('429', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 08:00:00'), ('430', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 08:30:00'), ('431', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 09:00:00'), ('432', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 09:30:00'), ('433', '1', 'testTask', 'test', 'renren', '0', null, '1058', '2017-10-27 10:00:00'), ('434', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-27 10:30:00'), ('435', '1', 'testTask', 'test', 'renren', '0', null, '1016', '2017-10-27 11:00:00'), ('436', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 11:30:00'), ('437', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-27 12:00:00'), ('438', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 12:30:00'), ('439', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-27 13:00:00'), ('440', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 13:30:00'), ('441', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-27 14:00:00'), ('442', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 14:30:00'), ('443', '1', 'testTask', 'test', 'renren', '0', null, '1074', '2017-10-27 15:00:00'), ('444', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 15:30:00'), ('445', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 16:00:00'), ('446', '1', 'testTask', 'test', 'renren', '0', null, '1063', '2017-10-27 17:00:00'), ('447', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 17:30:00'), ('448', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 18:00:00'), ('449', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-27 18:30:00'), ('450', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 19:00:00'), ('451', '1', 'testTask', 'test', 'renren', '0', null, '1070', '2017-10-27 19:30:00'), ('452', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-27 20:00:00'), ('453', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-27 20:30:00'), ('454', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 21:00:00'), ('455', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 21:30:00'), ('456', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 22:00:00'), ('457', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-27 22:30:00'), ('458', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-27 23:00:00'), ('459', '1', 'testTask', 'test', 'renren', '0', null, '1083', '2017-10-27 23:30:00'), ('460', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 00:00:00'), ('461', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 00:30:00'), ('462', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-28 01:00:00'), ('463', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 01:30:00'), ('464', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 02:00:00'), ('465', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 02:30:00'), ('466', '1', 'testTask', 'test', 'renren', '0', null, '1017', '2017-10-28 03:00:00'), ('467', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 03:30:00'), ('468', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-28 04:00:00'), ('469', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 04:30:00'), ('470', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 05:00:00'), ('471', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-28 05:30:00'), ('472', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 06:00:00'), ('473', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 06:30:00'), ('474', '1', 'testTask', 'test', 'renren', '0', null, '1018', '2017-10-28 07:00:00'), ('475', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-28 07:30:00'), ('476', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 08:00:00'), ('477', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 08:30:00'), ('478', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 09:00:00'), ('479', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 09:30:00'), ('480', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 10:00:00'), ('481', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-28 10:30:00'), ('482', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 11:00:00'), ('483', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 11:30:00'), ('484', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 12:00:00'), ('485', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 12:30:00'), ('486', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-28 13:00:00'), ('487', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 13:30:00'), ('488', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 14:00:00'), ('489', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 14:30:00'), ('490', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 15:00:00'), ('491', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 15:30:00'), ('492', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 16:00:00'), ('493', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 16:30:00'), ('494', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-28 17:00:00'), ('495', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 17:30:00'), ('496', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 18:00:00'), ('497', '1', 'testTask', 'test', 'renren', '0', null, '1062', '2017-10-28 18:30:00'), ('498', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 19:00:00'), ('499', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-28 19:30:00'), ('500', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 20:00:00'), ('501', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-28 20:30:00'), ('502', '1', 'testTask', 'test', 'renren', '0', null, '1005', '2017-10-28 21:00:00'), ('503', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-28 21:30:00'), ('504', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 22:00:00'), ('505', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 22:30:00'), ('506', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-28 23:00:00'), ('507', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-28 23:30:00'), ('508', '1', 'testTask', 'test', 'renren', '0', null, '1016', '2017-10-29 00:00:00'), ('509', '1', 'testTask', 'test', 'renren', '0', null, '1020', '2017-10-29 00:30:00'), ('510', '1', 'testTask', 'test', 'renren', '0', null, '1022', '2017-10-29 01:00:00'), ('511', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 01:30:00'), ('512', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-29 02:00:00'), ('513', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 02:30:00'), ('514', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-29 03:00:00'), ('515', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-29 03:30:00'), ('516', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 04:00:00'), ('517', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 04:30:00'), ('518', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-29 05:00:00'), ('519', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 05:30:00'), ('520', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 06:00:00'), ('521', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-29 06:30:00'), ('522', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-29 07:00:00'), ('523', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-29 07:30:00'), ('524', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 08:00:00'), ('525', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 08:30:00'), ('526', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 09:00:00'), ('527', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 09:30:00'), ('528', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-29 10:00:00'), ('529', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 10:30:00'), ('530', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-29 11:00:00'), ('531', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 11:30:00'), ('532', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-29 12:00:00'), ('533', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-29 12:30:00'), ('534', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 13:00:00'), ('535', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 13:30:00'), ('536', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 14:00:00'), ('537', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-29 14:30:00'), ('538', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 15:00:00'), ('539', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 15:30:00'), ('540', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-29 16:00:00'), ('541', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 16:30:00'), ('542', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-29 17:00:00'), ('543', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 17:30:00'), ('544', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-29 18:00:00'), ('545', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 18:30:00'), ('546', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 19:00:00'), ('547', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-29 19:30:00'), ('548', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 20:00:00'), ('549', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 20:30:00'), ('550', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 21:00:00'), ('551', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 21:30:00'), ('552', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 22:00:00'), ('553', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-29 22:30:00'), ('554', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 23:00:00'), ('555', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-29 23:30:00'), ('556', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-30 00:00:00'), ('557', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 00:30:00'), ('558', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 01:00:00'), ('559', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 01:30:00'), ('560', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-30 02:00:00'), ('561', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-30 02:30:00'), ('562', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 03:00:00'), ('563', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 03:30:00'), ('564', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-30 04:00:00'), ('565', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-30 04:30:00'), ('566', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 05:00:00'), ('567', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 05:30:00'), ('568', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 06:00:00'), ('569', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 06:30:00'), ('570', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 07:00:00'), ('571', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 07:30:00'), ('572', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-30 08:00:00'), ('573', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-30 08:30:00'), ('574', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 09:00:00'), ('575', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 09:30:00'), ('576', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-30 10:00:00'), ('577', '1', 'testTask', 'test', 'renren', '0', null, '1039', '2017-10-30 10:30:00'), ('578', '1', 'testTask', 'test', 'renren', '0', null, '1074', '2017-10-30 11:00:00'), ('579', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-30 11:30:00'), ('580', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-30 12:00:00'), ('581', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-30 12:30:00'), ('582', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 13:00:00'), ('583', '1', 'testTask', 'test', 'renren', '0', null, '1079', '2017-10-30 13:30:00'), ('584', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 14:00:00'), ('585', '1', 'testTask', 'test', 'renren', '0', null, '1045', '2017-10-30 14:30:00'), ('586', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-30 15:00:00'), ('587', '1', 'testTask', 'test', 'renren', '0', null, '1015', '2017-10-30 15:30:00'), ('588', '1', 'testTask', 'test', 'renren', '0', null, '1049', '2017-10-30 16:30:00'), ('589', '1', 'testTask', 'test', 'renren', '0', null, '1014', '2017-10-30 17:00:00'), ('590', '1', 'testTask', 'test', 'renren', '0', null, '1059', '2017-10-30 17:30:00'), ('591', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-30 18:00:00'), ('592', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-30 18:30:00'), ('593', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 19:00:00'), ('594', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-30 19:30:00'), ('595', '1', 'testTask', 'test', 'renren', '0', null, '1013', '2017-10-30 20:00:00'), ('596', '1', 'testTask', 'test', 'renren', '0', null, '1046', '2017-10-30 20:30:00'), ('597', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-30 21:00:00'), ('598', '1', 'testTask', 'test', 'renren', '0', null, '1057', '2017-10-30 21:30:00'), ('599', '1', 'testTask', 'test', 'renren', '0', null, '1050', '2017-10-30 22:00:00'), ('600', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-30 22:30:00'), ('601', '1', 'testTask', 'test', 'renren', '0', null, '1042', '2017-10-30 23:00:00'), ('602', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-30 23:30:00'), ('603', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-31 00:00:00'), ('604', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-31 00:30:00'), ('605', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 01:00:00'), ('606', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 01:30:00'), ('607', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 02:00:00'), ('608', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 02:30:00'), ('609', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 03:00:00'), ('610', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 03:30:00'), ('611', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 04:00:00'), ('612', '1', 'testTask', 'test', 'renren', '0', null, '1012', '2017-10-31 04:30:00'), ('613', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 05:00:00'), ('614', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-31 05:30:00'), ('615', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 06:00:00'), ('616', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-31 06:30:00'), ('617', '1', 'testTask', 'test', 'renren', '0', null, '1011', '2017-10-31 07:00:00'), ('618', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-31 07:30:00'), ('619', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 08:00:00'), ('620', '1', 'testTask', 'test', 'renren', '0', null, '1009', '2017-10-31 08:30:00'), ('621', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-31 09:00:00'), ('622', '1', 'testTask', 'test', 'renren', '0', null, '1054', '2017-10-31 09:30:00'), ('623', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-31 10:00:00'), ('624', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-31 10:30:00'), ('625', '1', 'testTask', 'test', 'renren', '0', null, '1006', '2017-10-31 11:00:00'), ('626', '1', 'testTask', 'test', 'renren', '0', null, '1052', '2017-10-31 11:30:00'), ('627', '1', 'testTask', 'test', 'renren', '0', null, '1010', '2017-10-31 12:00:00'), ('628', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 12:30:00'), ('629', '1', 'testTask', 'test', 'renren', '0', null, '1007', '2017-10-31 13:00:00'), ('630', '1', 'testTask', 'test', 'renren', '0', null, '1008', '2017-10-31 13:30:00');
COMMIT;

-- ----------------------------
--  Table structure for `sys_config`
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key` varchar(50) DEFAULT NULL COMMENT 'key',
  `value` varchar(2000) DEFAULT NULL COMMENT 'value',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态   0：隐藏   1：显示',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置信息表';

-- ----------------------------
--  Records of `sys_config`
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES ('1', 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', '0', '云存储配置信息');
COMMIT;

-- ----------------------------
--  Table structure for `sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `dept_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门ID，一级部门为0',
  `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `del_flag` tinyint(4) DEFAULT '0' COMMENT '是否删除  -1：已删除  0：正常',
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='部门管理';

-- ----------------------------
--  Records of `sys_dept`
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES ('1', '0', '运营平台-总公司', '0', '0'), ('2', '1', 'XX公司', '1', '0'), ('3', '1', '上海分公司', '2', '-1'), ('4', '3', '技术部', '0', '-1'), ('5', '3', '销售部', '1', '-1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `method` varchar(200) DEFAULT NULL COMMENT '请求方法',
  `params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
  `time` bigint(20) NOT NULL COMMENT '执行时长(毫秒)',
  `ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='系统日志';

-- ----------------------------
--  Records of `sys_log`
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES ('1', 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":4,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"公司管理\",\"url\":\"modules/sys/menu.html\",\"type\":1,\"icon\":\"fa fa-th-list\",\"orderNum\":3}', '27', '0:0:0:0:0:0:0:1', '2017-10-18 10:06:13'), ('2', 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":4,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"菜单管理\",\"url\":\"modules/sys/menu.html\",\"type\":1,\"icon\":\"fa fa-th-list\",\"orderNum\":3}', '23', '0:0:0:0:0:0:0:1', '2017-10-18 10:08:59'), ('3', 'admin', '修改菜单', 'io.renren.modules.sys.controller.SysMenuController.update()', '{\"menuId\":31,\"parentId\":1,\"parentName\":\"系统管理\",\"name\":\"公司管理\",\"url\":\"modules/sys/dept.html\",\"type\":1,\"icon\":\"fa fa-file-code-o\",\"orderNum\":1}', '25', '0:0:0:0:0:0:0:1', '2017-10-18 10:09:17'), ('4', 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '{\"userId\":1,\"username\":\"admin\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13612345678\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Nov 11, 2016 11:11:11 AM\",\"deptId\":1,\"deptName\":\"运营平台-总公司\"}', '89', '0:0:0:0:0:0:0:1', '2017-10-18 10:09:32'), ('5', 'admin', '保存用户', 'io.renren.modules.sys.controller.SysUserController.save()', '{\"userId\":2,\"username\":\"lsladmin\",\"password\":\"d475b3188431df4315e88a670c86c391df21315e35caabe9ff104a5c3da72301\",\"salt\":\"APTEvydxuIMRxmJvbhoB\",\"email\":\"lsladmin@lsladmin.com\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Oct 21, 2017 1:46:56 PM\",\"deptId\":1,\"deptName\":\"运营平台-总公司\"}', '28', '115.236.188.90', '2017-10-21 13:46:56'), ('6', 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '{\"userId\":1,\"username\":\"admin\",\"salt\":\"YzcmCZNvbXocrsz9dm8e\",\"email\":\"root@renren.io\",\"mobile\":\"13612345678\",\"status\":1,\"roleIdList\":[],\"createUserId\":1,\"createTime\":\"Nov 11, 2016 11:11:11 AM\",\"deptId\":1,\"deptName\":\"运营平台-总公司\"}', '29', '115.236.188.90', '2017-10-21 13:47:10'), ('7', 'admin', '保存角色', 'io.renren.modules.sys.controller.SysRoleController.save()', '{\"roleId\":1,\"roleName\":\"lsl-admin\",\"deptId\":1,\"deptName\":\"运营平台-总公司\",\"menuIdList\":[1,2,15,16,17,18,31,32,33,34,35,3,19,20,21,22,29],\"deptIdList\":[1,2],\"createTime\":\"Oct 21, 2017 1:48:56 PM\"}', '53', '115.236.188.90', '2017-10-21 13:48:56'), ('8', 'admin', '修改用户', 'io.renren.modules.sys.controller.SysUserController.update()', '{\"userId\":2,\"username\":\"lsladmin\",\"salt\":\"APTEvydxuIMRxmJvbhoB\",\"email\":\"lsladmin@lsladmin.com\",\"status\":1,\"roleIdList\":[1],\"createUserId\":1,\"createTime\":\"Oct 21, 2017 1:46:56 PM\",\"deptId\":1,\"deptName\":\"运营平台-总公司\"}', '27', '115.236.188.90', '2017-10-21 13:49:08'), ('9', 'admin', '修改密码', 'io.renren.modules.sys.controller.SysUserController.password()', '\"admin\"', '20', '115.236.188.90', '2017-10-21 15:57:57');
COMMIT;

-- ----------------------------
--  Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
  `type` int(11) DEFAULT NULL COMMENT '类型   0：目录   1：菜单   2：按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='菜单管理';

-- ----------------------------
--  Records of `sys_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', null, null, '0', 'fa fa-cog', '0'), ('2', '1', '管理员管理', 'modules/sys/user.html', null, '1', 'fa fa-user', '1'), ('3', '1', '角色管理', 'modules/sys/role.html', null, '1', 'fa fa-user-secret', '2'), ('4', '1', '菜单管理', 'modules/sys/menu.html', null, '1', 'fa fa-th-list', '3'), ('5', '1', 'SQL监控', 'druid/sql.html', null, '1', 'fa fa-bug', '4'), ('6', '1', '定时任务', 'modules/job/schedule.html', null, '1', 'fa fa-tasks', '5'), ('7', '6', '查看', null, 'sys:schedule:list,sys:schedule:info', '2', null, '0'), ('8', '6', '新增', null, 'sys:schedule:save', '2', null, '0'), ('9', '6', '修改', null, 'sys:schedule:update', '2', null, '0'), ('10', '6', '删除', null, 'sys:schedule:delete', '2', null, '0'), ('11', '6', '暂停', null, 'sys:schedule:pause', '2', null, '0'), ('12', '6', '恢复', null, 'sys:schedule:resume', '2', null, '0'), ('13', '6', '立即执行', null, 'sys:schedule:run', '2', null, '0'), ('14', '6', '日志列表', null, 'sys:schedule:log', '2', null, '0'), ('15', '2', '查看', null, 'sys:user:list,sys:user:info', '2', null, '0'), ('16', '2', '新增', null, 'sys:user:save,sys:role:select', '2', null, '0'), ('17', '2', '修改', null, 'sys:user:update,sys:role:select', '2', null, '0'), ('18', '2', '删除', null, 'sys:user:delete', '2', null, '0'), ('19', '3', '查看', null, 'sys:role:list,sys:role:info', '2', null, '0'), ('20', '3', '新增', null, 'sys:role:save,sys:menu:perms', '2', null, '0'), ('21', '3', '修改', null, 'sys:role:update,sys:menu:perms', '2', null, '0'), ('22', '3', '删除', null, 'sys:role:delete', '2', null, '0'), ('23', '4', '查看', null, 'sys:menu:list,sys:menu:info', '2', null, '0'), ('24', '4', '新增', null, 'sys:menu:save,sys:menu:select', '2', null, '0'), ('25', '4', '修改', null, 'sys:menu:update,sys:menu:select', '2', null, '0'), ('26', '4', '删除', null, 'sys:menu:delete', '2', null, '0'), ('27', '1', '参数管理', 'modules/sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', '1', 'fa fa-sun-o', '6'), ('29', '1', '系统日志', 'modules/sys/log.html', 'sys:log:list', '1', 'fa fa-file-text-o', '7'), ('30', '1', '文件上传', 'modules/oss/oss.html', 'sys:oss:all', '1', 'fa fa-file-image-o', '6'), ('31', '1', '公司管理', 'modules/sys/dept.html', null, '1', 'fa fa-file-code-o', '1'), ('32', '31', '查看', null, 'sys:dept:list,sys:dept:info', '2', null, '0'), ('33', '31', '新增', null, 'sys:dept:save,sys:dept:select', '2', null, '0'), ('34', '31', '修改', null, 'sys:dept:update,sys:dept:select', '2', null, '0'), ('35', '31', '删除', null, 'sys:dept:delete', '2', null, '0');
COMMIT;

-- ----------------------------
--  Table structure for `sys_oss`
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传';

-- ----------------------------
--  Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色';

-- ----------------------------
--  Records of `sys_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', 'lsl-admin', null, '1', '2017-10-21 13:48:56');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色与部门对应关系';

-- ----------------------------
--  Records of `sys_role_dept`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` VALUES ('1', '1', '1'), ('2', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';

-- ----------------------------
--  Records of `sys_role_menu`
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1', '1', '1'), ('2', '1', '2'), ('3', '1', '15'), ('4', '1', '16'), ('5', '1', '17'), ('6', '1', '18'), ('7', '1', '31'), ('8', '1', '32'), ('9', '1', '33'), ('10', '1', '34'), ('11', '1', '35'), ('12', '1', '3'), ('13', '1', '19'), ('14', '1', '20'), ('15', '1', '21'), ('16', '1', '22'), ('17', '1', '29');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `salt` varchar(20) DEFAULT NULL COMMENT '盐',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：禁用   1：正常',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='系统用户';

-- ----------------------------
--  Records of `sys_user`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('1', 'admin', 'e2986e886b7586168f461965a6843992608c9afa86e1f4cffa62850374f06df5', 'YzcmCZNvbXocrsz9dm8e', 'root@renren.io', '13612345678', '1', '1', '2016-11-11 11:11:11'), ('2', 'lsladmin', 'd475b3188431df4315e88a670c86c391df21315e35caabe9ff104a5c3da72301', 'APTEvydxuIMRxmJvbhoB', 'lsladmin@lsladmin.com', null, '1', '1', '2017-10-21 13:46:56');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';

-- ----------------------------
--  Records of `sys_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '2', '1');
COMMIT;

-- ----------------------------
--  Table structure for `sys_user_token`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户Token';

-- ----------------------------
--  Records of `sys_user_token`
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_token` VALUES ('1', 'a8a994dd6e64e7f7b9fb0e13df35d936', '2017-10-22 03:57:43', '2017-10-21 15:57:43'), ('2', '0ce99cb0108edf87fb46c299436ba662', '2017-10-22 03:58:15', '2017-10-21 15:58:15');
COMMIT;

-- ----------------------------
--  Table structure for `tb_token`
-- ----------------------------
DROP TABLE IF EXISTS `tb_token`;
CREATE TABLE `tb_token` (
  `user_id` bigint(20) NOT NULL,
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_time` datetime DEFAULT NULL COMMENT '过期时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户Token';

-- ----------------------------
--  Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
--  Records of `tb_user`
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES ('1', 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2017-03-23 22:37:41');
COMMIT;

-- ----------------------------
--  Procedure structure for `base_data_init`
-- ----------------------------
DROP PROCEDURE IF EXISTS `base_data_init`;
delimiter ;;
CREATE DEFINER=`lslease`@`%` PROCEDURE `base_data_init`()
BEGIN
	DELETE From app_sys_role;
	#INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10026, '未知角色', -1, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10027, '系统用户', 1, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10028, '租客', 2, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10029, '房东', 4, '添加角色', NOW(), NOW());
	#INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10030, '既是租客也是房东', 8, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10031, '安装工人', 16, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10032, '房东授权的管理员', 32, '添加角色', NOW(), NOW());
END
 ;;
delimiter ;

-- ----------------------------
--  Procedure structure for `clear_user_data_by_mobile`
-- ----------------------------
DROP PROCEDURE IF EXISTS `clear_user_data_by_mobile`;
delimiter ;;
CREATE DEFINER=`lslease`@`%` PROCEDURE `clear_user_data_by_mobile`()
    DETERMINISTIC
BEGIN
	DELETE From app_sys_role;
	#INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10026, '未知角色', -1, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10027, '系统用户', 1, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10028, '租客', 2, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10029, '房东', 4, '添加角色', NOW(), NOW());
	#INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10030, '既是租客也是房东', 8, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10031, '安装工人', 16, '添加角色', NOW(), NOW());
	INSERT INTO app_sys_role(id, name, type, remark, insert_time, update_time) VALUES(10032, '房东授权的管理员', 32, '添加角色', NOW(), NOW());
END
 ;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
